

/****** Object:  Table [dbo].[CommonStockInfo]    Script Date: 11/23/2012 00:06:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[CommonStockInfo](
	[ListID] [bigint] IDENTITY(1,1) NOT NULL,
	[StockCode] [varchar](10) NULL,
	[StockName] [nvarchar](50) NULL,
	[Date] [smalldatetime] NULL,
	[ClosePrice] [decimal](9, 2) NULL,
	[CeilingPrice] [decimal](9, 2) NULL,
	[FloorPrice] [decimal](9, 2) NULL,
	[OpenPrice] [decimal](9, 2) NULL,
	[LastClosePrice] [decimal](9, 2) NULL,
	[FloatPrice] [decimal](9, 2) NULL,
	[FloatPercent] [decimal](9, 4) NULL,
	[TurnOverRate] [decimal](9, 4) NULL,
	[VolumnCount] [int] NULL,
	[VolumnAmount] [decimal](15, 2) NULL,
	[MarketCap] [bigint] NULL,
	[MarketCapCirculate] [bigint] NULL,
	[IsActive] [bit] NULL,
	[CreateTime] [datetime] NULL,
	[Remark] [nvarchar](4000) NULL,
 CONSTRAINT [PK_CommonStockInfo] PRIMARY KEY CLUSTERED 
(
	[ListID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


